<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="hk141670">pg_resqueuecapability</title>
  <body>
    <note>The <codeph>pg_resqueuecapability</codeph> system catalog table is valid only when resource queue-based resource management is active.</note>
    <p>The <codeph>pg_resqueuecapability</codeph> system catalog table contains information about
      the extended attributes, or capabilities, of existing Greenplum Database
      resource queues. Only resource queues that have been assigned an extended capability, such as
      a priority setting, are recorded in this table. This table is joined to the <xref
        href="pg_resqueue.xml#topic1" type="topic" format="dita"/> table by resource queue object
      ID, and to the <xref href="pg_resourcetype.xml#topic1" type="topic" format="dita"/> table by
      resource type ID (<codeph>restypid</codeph>).</p>
    <p>This table is populated only on the master. This table is defined in the
        <codeph>pg_global</codeph> tablespace, meaning it is globally shared across all databases in
      the system.</p>
    <table id="hk141982">
      <title>pg_catalog.pg_resqueuecapability</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="105.75pt"/>
        <colspec colnum="2" colname="col2" colwidth="86pt"/>
        <colspec colnum="3" colname="col3" colwidth="122.25pt"/>
        <colspec colnum="4" colname="col4" colwidth="147pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col3">references</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1">
              <codeph>rsqueueid</codeph>
            </entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3">
              <codeph>pg_resqueue.oid</codeph>
            </entry>
            <entry colname="col4">The object ID of the associated resource queue.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>restypid </codeph>
            </entry>
            <entry colname="col2">smallint</entry>
            <entry colname="col3">
              <codeph>pg_resourcetype. restypid</codeph>
            </entry>
            <entry colname="col4">The resource type, derived from the <i><xref
                  href="pg_resourcetype.xml#topic1" format="dita">pg_resqueuecapability</xref></i>
              system table.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>resetting</codeph>
            </entry>
            <entry colname="col2">opaque type</entry>
            <entry colname="col3"/>
            <entry colname="col4">The specific value set for the capability referenced in this
              record. Depending on the actual resource type, this value may have different data
              types. </entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
